UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R2q9OptOwcWdqHOvIXYe0TRYqxRvZ0O5LHqw0APk53w='
WHERE
key_id = '8c17da1e8ac9badb5e4243fdaa40ca703f32d16a3a01a70d149921b59b53f8a2'
AND (
token = 'R2q9OptOwcWdqHOvIXYe0TRYqxRvZ0O5LHqw0APk53w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)