UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CCiYTheM4NQ5KG6EMpQSY6Ty+wb0HZGRGKRy+5hxMHk='
WHERE
key_id = '88caa958464fafdc6d1df0435717d054d11deb9193655e2252e452328eeecb07'
AND (
token = 'CCiYTheM4NQ5KG6EMpQSY6Ty+wb0HZGRGKRy+5hxMHk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)