UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mtwg2dTD8cf2gPOvE/AKBwGGlnY6ntfioeR0wX5lDi4='
WHERE
key_id = 'c50675a68ea5834c4281f6a4093084b897924121f381f894a2dd49f34a846b3a'
AND (
token = 'mtwg2dTD8cf2gPOvE/AKBwGGlnY6ntfioeR0wX5lDi4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)