UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RC9XzP1oY2DXGB4MHmvdgvg4ByWKE+c/Yx3/EG1MVr8='
WHERE
key_id = '0173d38f97cfdf001ea8bb5d95c40678057577e7a91878382437390ca5867d91'
AND (
token = 'RC9XzP1oY2DXGB4MHmvdgvg4ByWKE+c/Yx3/EG1MVr8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)