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