UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6wWpQklYfryWDFTH//2Thzh2UxSTfA8BuBy9Og82tTw='
WHERE
key_id = '5ec01db5f4e704b941ead4ab274df83a69429944524bc134e124eee384bde655'
AND (
token = '6wWpQklYfryWDFTH//2Thzh2UxSTfA8BuBy9Og82tTw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)