UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S+p0ixM4aj0GTTGT9NyZe8JanTqvvYWKT0hqkHdoAV4='
WHERE
key_id = 'bc2489e052979d39496d7d0dc09b134abb4b1feda3ea5f2e75d10a7cc95d5dd2'
AND (
token = 'S+p0ixM4aj0GTTGT9NyZe8JanTqvvYWKT0hqkHdoAV4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)