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