UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JK/XlzANqSzC7Dep7nVSj75n3XLEYqZPvAA6HeuUzjk='
WHERE
key_id = '4b66939292aa70732b28075b41efc4a988a814c7ffdb089ea0bb8a81a5991dc9'
AND (
token = 'JK/XlzANqSzC7Dep7nVSj75n3XLEYqZPvAA6HeuUzjk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)