UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xcpyrZtVwl4OIvWwLzT3AYV6C4zBsrc5V9KoVHOpV4Q='
WHERE
key_id = '6cc47d53766a096341535cb92b70dd7ac229de6fb5e6d8a80ff1594efad436f5'
AND (
token = 'xcpyrZtVwl4OIvWwLzT3AYV6C4zBsrc5V9KoVHOpV4Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)