UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x0HUBc86EoPRAMkgcx2hxJW35vE907chTjDpfHsXnK4='
WHERE
key_id = '887c8e2da55c3cd8b1825162266f5330bda7c78f83620a9b7b15a8b99b9d58f0'
AND (
token = 'x0HUBc86EoPRAMkgcx2hxJW35vE907chTjDpfHsXnK4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)