UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T42RkSOzemnT5WKSj8bOYibpK/NiW3IgZbl8NA2MAYY='
WHERE
key_id = 'ee394b8a700a4ed8d0a14b383dfe62672515e88b598ac2e62aa4e386e0e167b8'
AND (
token = 'T42RkSOzemnT5WKSj8bOYibpK/NiW3IgZbl8NA2MAYY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)