UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D+54duyap1a5ZDXeLHZI7UDxhmUfqfCHVLT8cCiGIAs='
WHERE
key_id = '0fc3ff7054b121b12ba3a05b5703d0201a5a205518a20880a73293de3134be85'
AND (
token = 'D+54duyap1a5ZDXeLHZI7UDxhmUfqfCHVLT8cCiGIAs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)