UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TBnxWTRtXjPbE7kZ9pThbyUwakdhWyo7USkbyXipQ/w='
WHERE
key_id = 'd9b4de90124bef8360851288c27ea19fb6028c12930499c3be49817ca53f501f'
AND (
token = 'TBnxWTRtXjPbE7kZ9pThbyUwakdhWyo7USkbyXipQ/w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)