UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KDjLBK1fDCTbDu/oTKbbhNN6r5kc98gZojmZFaARknM='
WHERE
key_id = '2d4a8f2ef3d4495c22b62999131bd312fd4075210148f9a1f14855a516628abf'
AND (
token = 'KDjLBK1fDCTbDu/oTKbbhNN6r5kc98gZojmZFaARknM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)