UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zgwz1Jweq+LenNxoYghxj52FlVuFWsuImEyoUgdEztU='
WHERE
key_id = '8c54154e02454dd340861af0c7f6954068fe38806421823a0db2a86e666eab8e'
AND (
token = 'zgwz1Jweq+LenNxoYghxj52FlVuFWsuImEyoUgdEztU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)