UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '38tKjXAruhL48WAr2d1hWwA9IMs0Q87A0b/mcqhiqws='
WHERE
key_id = 'b174f468b0d1f039b114f48352c8b60d7b63bd18b55c4a17f0adcb86fb01a755'
AND (
token = '38tKjXAruhL48WAr2d1hWwA9IMs0Q87A0b/mcqhiqws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)