UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8wnmQxn4SM6hRvjsJiHdEHJfodELUY6jo535y3YzVmo='
WHERE
key_id = '078bccc490476935360454ffe18311dc973eb6682a71e7c333532c3ef4300f15'
AND (
token = '8wnmQxn4SM6hRvjsJiHdEHJfodELUY6jo535y3YzVmo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)