UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DczpqvUDT1PqYifUGzOlCBoLSnwwW9zxhYNO1unoPHY='
WHERE
key_id = '55fc6035be590a1420305c000fee44fa86fdbde429048ec92dbb665ec805b9ef'
AND (
token = 'DczpqvUDT1PqYifUGzOlCBoLSnwwW9zxhYNO1unoPHY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)