UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+pZ4L0oBOxqtF6Bd4UXMoHFQBJVAi29LLGG3QP6j6gM='
WHERE
key_id = 'de249a7ed1c5001ce709ebb21458e8481d2f39ea1646a548ce89095fdf0398b2'
AND (
token = '+pZ4L0oBOxqtF6Bd4UXMoHFQBJVAi29LLGG3QP6j6gM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)