UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xV8zp9GyXcbub+8kiOfrJs/m+6N+0yzrOBygU0EKCvE='
WHERE
key_id = '81c5ed98d011d327a007c5a1587c27cdcfacc60aa0d2e9d621166fdc58d33a57'
AND (
token = 'xV8zp9GyXcbub+8kiOfrJs/m+6N+0yzrOBygU0EKCvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)