UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nva0sxZfXgggn1h9Y0csRQjEYOiqK7mybfo3keT7J3k='
WHERE
key_id = 'ad51880fff13be973326fd620f18d701f869c12fdfe5be7a86a2ea68b97a1709'
AND (
token = 'nva0sxZfXgggn1h9Y0csRQjEYOiqK7mybfo3keT7J3k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)