UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UX3pHoA/2mTXRHZs3f9aX/O8L5D2pDSFEnFIRRHI7yc='
WHERE
key_id = '8c0d334b8e09818838437a2d71d19e9c7f48534b6f0a25ed5688756da6dcc7d9'
AND (
token = 'UX3pHoA/2mTXRHZs3f9aX/O8L5D2pDSFEnFIRRHI7yc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)