UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yZHLu0MxusKvzkM01EdH2u4ympnkWHWrDpVu/FDX3Xw='
WHERE
key_id = 'd06a7eb6bd830f2bc98ae819a3f7542e27c2c15e554aa19106aef827237dc812'
AND (
token = 'yZHLu0MxusKvzkM01EdH2u4ympnkWHWrDpVu/FDX3Xw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)