UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o2dWtm9c46lPWDddxf0KmyUMcYNIvZGCQhXqEI4Bm40='
WHERE
key_id = '0e867eac527ca2f2ab52ab48c894993d2e9483fee08e9f1c06517b314acfe68f'
AND (
token = 'o2dWtm9c46lPWDddxf0KmyUMcYNIvZGCQhXqEI4Bm40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)