UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4nW+0kVmYw+rZ8X6JYTxz4m78CKMvhMwqfXQrWq3D8c='
WHERE
key_id = '0754d20d6310867b0d4faec4f7f6ac2b54af0054979e69ebb96cf64a704bb8ab'
AND (
token = '4nW+0kVmYw+rZ8X6JYTxz4m78CKMvhMwqfXQrWq3D8c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)