UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5iL64emF7cnWHKJDRbkHk9tQ671f40J6wP84ZwF1rtc='
WHERE
key_id = 'd1001304f03205e509441bf1ed13e968e883220517c0367fc84c6c06ab015c59'
AND (
token = '5iL64emF7cnWHKJDRbkHk9tQ671f40J6wP84ZwF1rtc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)