UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3xG46VmkLtX24O1N6D0oRdcgQeQCT7HAaIX3lAJ4z/4='
WHERE
key_id = '4dfa782c0603b6a4ad23a0645c38c91745cc0f010eafa617459f28583b833a3e'
AND (
token = '3xG46VmkLtX24O1N6D0oRdcgQeQCT7HAaIX3lAJ4z/4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)