UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WGsoYxaR5l5H8iC7KJd482HMrwn/cEGDi7mLfcD+8XA='
WHERE
key_id = '8e7e69a1be3f353c90efca844de09f09d00e013bd1c677d31be24cf2e79a3a5b'
AND (
token = 'WGsoYxaR5l5H8iC7KJd482HMrwn/cEGDi7mLfcD+8XA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)