UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BZjxfZzyXYt1EuQlt9+j5m3enPCTXgzESEzFE9UcCZI='
WHERE
key_id = '581d314c8564094e8561338ffb0eecda29bcc65d70f757d48ec923a8f3e723c8'
AND (
token = 'BZjxfZzyXYt1EuQlt9+j5m3enPCTXgzESEzFE9UcCZI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)