UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U4xBg+EMMwMujyCek0BkIiDkmytyz9iDUqvGP2weXHM='
WHERE
key_id = '9e399cc2da5c6d8496fde5b55816ba5b87dfef21681cc45d17439761046a4206'
AND (
token = 'U4xBg+EMMwMujyCek0BkIiDkmytyz9iDUqvGP2weXHM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)