UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gkmfmLQ4KY156z+QRfMJroBmRz1kH96jBB+zVGpzWvA='
WHERE
key_id = 'ac900b4c23037d22766f8af7b313d36a4a534dbd70922025cd6ed791e7bfd080'
AND (
token = 'gkmfmLQ4KY156z+QRfMJroBmRz1kH96jBB+zVGpzWvA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)