UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GKHfgYYL0kF65xkZsFDoEJIDNj+Q6qumqvDSiivluoA='
WHERE
key_id = 'c12d5ac64cd00cb1c43400525326522359d81977424bb829d6be4789ee6cf7d9'
AND (
token = 'GKHfgYYL0kF65xkZsFDoEJIDNj+Q6qumqvDSiivluoA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)