UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qCC4/7B+Jfd4mCZozMABGqNYKKhai/xv6eErJV0sIsw='
WHERE
key_id = 'e47c01c2f46f359c29c04425adb23d22018d79a58c5fa009bb2d29f6ceb7f87a'
AND (
token = 'qCC4/7B+Jfd4mCZozMABGqNYKKhai/xv6eErJV0sIsw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)