UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZpXAKmy0U91etm75saVzAA/hlGbneUhfEqNJXtOXgJc='
WHERE
key_id = '817a5523053ef37ffdc9e3bf2e56691697165224be76f154f80919aea051dc79'
AND (
token = 'ZpXAKmy0U91etm75saVzAA/hlGbneUhfEqNJXtOXgJc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)